from openpyxl import load_workbook
import os
# # 路径可以不是本地路径
# f1 = open("data/价格清单表.xlsx", mode="rb")
# wb = load_workbook(f1)
# print(wb)
# f1.close()

filepath = os.path.join("data", "user_userinfo.xlsx")
wb = load_workbook(filepath)
# for row in wb.sheetnames:
for name in wb.worksheets:
    # sheet = wb[name]
    a = 0
    for row in name.iter_rows(min_row=2):
        cell = row[3]
        a += cell.value
    print(name.title, a)
